Tabela MealOrder

Definicja tabeli MealOrder

Name

MealOrder

Code

MealOrder

Comment

Zlecenia zamówienia posilków dla poszczególnych jednostek, w oparciu o typ posilku oraz rodzaj diety


Lista kolumn tabeli MealOrder

Name

Code

MealOrderID

MealOrderID

MealTypeID

MealTypeID

ResourceID

ResourceID

Day

Day

Quantity

Quantity

Active

Active

InsertingPerson

InsertingPerson

InsertDate

InsertDate

LastModifiedPerson

LastModifiedPerson

LastModifiedDT

LastModifiedDT


Kolumna MealOrderID tabeli MealOrder

Definicja kolumny MealOrderID tabeli MealOrder

Name

MealOrderID

Code

MealOrderID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID zlecenia zamówienia posilku


Kolumna MealTypeID tabeli MealOrder

Definicja kolumny MealTypeID tabeli MealOrder

Name

MealTypeID

Code

MealTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ResourceID tabeli MealOrder

Definicja kolumny ResourceID tabeli MealOrder

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Day tabeli MealOrder

Definicja kolumny Day tabeli MealOrder

Name

Day

Code

Day

Data Type

DATE

Mandatory

Yes

Comment

Data zamówienia


Kolumna Quantity tabeli MealOrder

Definicja kolumny Quantity tabeli MealOrder

Name

Quantity

Code

Quantity

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Ilosc


Kolumna Active tabeli MealOrder

Definicja kolumny Active tabeli MealOrder

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Aktywnosc rekordu


Kolumna InsertingPerson tabeli MealOrder

Definicja kolumny InsertingPerson tabeli MealOrder

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna InsertDate tabeli MealOrder

Definicja kolumny InsertDate tabeli MealOrder

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

Data utworzenia rekordu


Kolumna LastModifiedPerson tabeli MealOrder

Definicja kolumny LastModifiedPerson tabeli MealOrder

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

Ostatnio modyfikujaca osoba


Kolumna LastModifiedDT tabeli MealOrder

Definicja kolumny LastModifiedDT tabeli MealOrder

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Lista kluczy tabeli MealOrder

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli MealOrder

Definicja klucza Identifier_1 tabeli MealOrder

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment